Responsibilties Hands-on maintenance of PostgreSQL databases, ensuring uptime, reliability, and performance. Design and implement procedures for backup, failover, and recovery to deliver data integrity and business continuity. Provide hands-on database expertise to development teams, advising on schema design, indexing, and query optimization. Proactively monitor database health and performance; identify and resolve issues before they impact production. Collaborate with internal teams and service providers (AWS, Enterprise DB etc.) in the resolution of issues Work closely with DevOps and Engineering to integrate safe database change processes into delivery pipelines Establish and document database standards, policies, and best practices. Contribute to the broader data architecture strategy as the organization scales and evolves. Recommend and implement best practices for data security, compliance, and scalability. Define, agree and maintain improvement roadmap for the database estate. Proven experience required 6+ years of hands-on experience working with PostgreSQL in complex, production environments. Demonstrable expertise in hands-on operations, managing the ongoing hygiene of a postgreSQL estate including backup, point-in-time recovery, replication and failover – ideally with Barman and a PG load balancer. Deep technical knowledge of PostgreSQL internals with experience in query optimization, indexing strategies, and performance tuning of DB instance and host parameters. Experience working with cloud-based and/or containerized infrastructure Proficient in scripting (e.g., Bash, Python) to automate database operations and maintenance tasks. Solid understanding of Linux system administration as it relates to database performance and configuration. Demonstrates the drive and ability to independently identify required work, negotiate priorities and efficiently deliver on agreed objectives. Strong communication skills, with the ability to explain database concepts and trade-offs to both technical and non technical stakeholders. Desirable: Exposure to other database technologies (e.g., MySQL, MongoDB, Redis). Experience with observability and monitoring tools (e.g., Prometheus, Grafana, pg_stat_statements). Experience with infrastructure-as-code techniques (e.g. Terraform, Ansilble) Working Conditions Office based: 5 days in Kochi office and shift time will be from 11 am to 8pm IST Job Types: Full-time, Permanent Pay: ₹3,500,000.00 - ₹4,200,000.00 per year Benefits: Commuter assistance Health insurance Paid sick time Provident Fund Schedule: Day shift Monday to Friday Morning shift Supplemental Pay: Joining bonus Ability to commute/relocate: Ernakulam, Kerala: Reliably commute or planning to relocate before starting work (Preferred) Application Question(s): Do you have experience in Bash/Python? What is your Notice Period? Experience: Database administration: 6 years (Preferred) PostgreSQL: 5 years (Preferred) Barman: 3 years (Preferred) Work Location: In person
